Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$TRANSACTION

`V$TRANSACTION` lists the active transactions in the system.

Column | Datatype | Description
--- | --- | ---
`ADDR` | `RAW(4 | 8)` | Address of the transaction state object
`XIDUSN` | `NUMBER` | Undo segment number
`XIDSLOT` | `NUMBER` | Slot number
`XIDSQN` | `NUMBER` | Sequence number
`UBAFIL` | `NUMBER` | Undo block address (UBA) filenum
`UBABLK` | `NUMBER` | UBA block number
`UBASQN` | `NUMBER` | UBA sequence number
`UBAREC` | `NUMBER` | UBA record number
`STATUS` | `VARCHAR2(16)` | Status
`START_TIME` | `VARCHAR2(20)` | Start time (wall clock)
`START_SCNB` | `NUMBER` | Start system change number (SCN) base
`START_SCNW` | `NUMBER` | Start SCN wrap
`START_UEXT` | `NUMBER` | Start extent number
`START_UBAFIL` | `NUMBER` | Start UBA file number
`START_UBABLK` | `NUMBER` | Start UBA block number
`START_UBASQN` | `NUMBER` | Start UBA sequence number
`START_UBAREC` | `NUMBER` | Start UBA record number
`SES_ADDR` | `RAW(4 | 8)` | User session object address
`FLAG` | `NUMBER` | Flag
`SPACE` | `VARCHAR2(3)` | `YES` if a space transaction
`RECURSIVE` | `VARCHAR2(3)` | `YES` if a recursive transaction
`NOUNDO` | `VARCHAR2(3)` | `YES` if a no undo transaction
`PTX` | `VARCHAR 2(3)` | `YES` if parallel transaction
`NAME` | `VARCHAR2(256)` | Name of a named transaction
`PRV_XIDUSN` | `NUMBER` | Previous transaction undo segment number
`PRV_XIDSLT` | `NUMBER` | Previous transaction slot number
`PRV_XIDSQN` | `NUMBER` | Previous transaction sequence number
`PTX_XIDUSN` | `NUMBER` | Rollback segment number of the parent XID
`PTX_XIDSLT` | `NUMBER` | Slot number of the parent XID
`PTX_XIDSQN` | `NUMBER` | Sequence number of the parent XID
`DSCN-B` | `NUMBER` | This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in `DSCN_BASE`.
`DSCN-W` | `NUMBER` | This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in `DSCN_WRAP`.
`USED_UBLK` | `NUMBER` | Number of undo blocks used
`USED_UREC` | `NUMBER` | Number of undo records used
`LOG_IO` | `NUMBER` | Logical I/O
`PHY_IO` | `NUMBER` | Physical I/O
`CR_GET` | `NUMBER` | Consistent gets
`CR_CHANGE` | `NUMBER` | Consistent changes
`START_DATE` | `DATE` | Start time (wall clock)
`DSCN_BASE` | `NUMBER` | Dependent SCN base
`DSCN_WRAP` | `NUMBER` | Dependent SCN wrap
`START_SCN` | `NUMBER` | Start SCN
`DEPENDENT_SCN` | `NUMBER` | Dependent SCN
`XID` | `RAW(8)` | Transaction XID
`PRV_XID` | `RAW(8)` | Previous transaction XID
`PTX_XID` | `RAW(8)` | Parent transaction XID